ExtractString (origin, startString, endString)

Basic and Crystal syntax.

Arguments

• Origin: String
• StartString: String
• EndString: String

Returns

String

Action

This function will return the first occurrence (in the Origin string) of a string that starts with the StartString and ends with EndString. If the EndString is not found, the string starting with StartString until the end of the string is returned.

Examples

The following examples are applicable to Basic syntax:

MyTable.Field = "James and crystal"
ExtractString (MyTable.Field, J, s)

Returns "Jame".

MyTable.Field = "James and crystal"
ExtractString (MyTable.Field, J, ;)

Returns "James and crystal".